use Dosvid
go

insert into Candidate_Positions(CandidateId,PositionId)
select c.Id, c.PositionID
from Candidates c
where c.PositionID is not null
go